package com.dao;

import com.util.DBpool.DBconnection;

/**
 * Created by wlc on 2018/7/26.
 */
public class SystemDao {
    /**
     * 获取计算部分QM数据条数
     * @return QM数据条数
     */
    public static int getQMPartDataNum(){
        DBconnection connection = new DBconnection();
//        qm
        connection.setSheet_name("QM_USER_AND_PBC");
        return connection.getDataNumFromDB();
    }

    /**
     * 获取实验部分数据条数
     * @return 实验数据条数
     */
    public static int getExperimentPartDataNum(){
        DBconnection connection = new DBconnection();
//        experiment
        connection.setSheet_name("experiment_User_AND_Method");

        return connection.getDataNumFromDB();
    }

    /**
     * 获取骨肿瘤随访部分数据条数
     * @return 随访数据条数
     */
    public static int getBoneTumorPartDataNum(){
        DBconnection connection = new DBconnection();
//        BoneTumor
        connection.setSheet_name("BoneTumor_user_Information");
        int BoneTumor = connection.getDataNumFromDB();

        //seer数据
        connection.setSheet_name("seer");
        int SEER = connection.getDataNumFromDB();

        return BoneTumor + SEER;
    }

    /**
     * 获取临床数据
     */
    public static int getClinicalPartDateNum() {
        //临时
        int image_num = 6354;
        return  image_num;
    }
}
